ExcelR Jumbo PassExcelR Jumbo Pass Video   You May Have Heard About Offers, But Have You Heard Of ExcelR's JUMBO PASS? Well, Here's Your Chance To Avail The JUMBO PASS!! Watch The video

Upcoming Batches

Select Your City

Click Here

Live Virtual Classroom

$ 249
  • 6-in-1 Combo Program With Value-Adds
  • Manual Testing
  • Selenium Fundamentals
  • MySQL
  • Agile
  • Jira
  • HTML Fundamentals
Upcoming Batches
21st

November

Show All Batches Enroll Now

Program Highlights

  • Fundamentals of testing
  • What is testing?
  • Testing principles
  • What is software, Types of Software Application (Desktop, Web & mobile), Types of Organizations
  • Type of Domains
  • Project & team Members
  • Testing throughout the software life cycle
  • Software development Models (Overview of all models)- SDLC
  • Water Fall Model
  • Agile Model, V Shape, Spiral Model (Adv & Dis-adv), Roles
  • Agile Model, Scrum framework, Roles, Ceremonies & Artifacts, Sprint, Scrum, Test managment tool (JIIRA, ZEPHYR)
  • Agile Model, Scrum framework, Roles, Ceremonies & Artifacts, Sprint, Scrum, Test managment tool (JIIRA, ZEPHYR)

Lab Session :
JIRA tool creating the project, Test cases, Basic tool handling

  • Fundamental test process (Overview of Understanding Requirements and creating Test Scenarios, Test design, Test Planning, test execution, test report) STLC

Lab Sessions :
Understanding Requirements and creating Test Scenarios

Environments: Development, QA, UAT, Prod

  • Test types :
    • White box testing
    • Black-box testing
    • Functional testing
    • Smoke & Sanity testing
    • Regression and Retesting
    • User acceptance testing - Alpha & Beta programs
    • Non-functional testing (Overview)
    • Usability testing
    • UI UX testing
    • L10N, I18N, G11N testing
    • Compatibility testing
    • Performance testing
    • Security testing
  • Test levels :
    • Unit Testing
    • Integration Testing
    • System Testing
    • UAT Testing
    • Prod Testing
  • Identifying test conditions and designing test cases
  • Categories of test design techniques:
  • Structure-based or white-box techniques (Overview)
  • Specification-based or black-box techniques

Lab Session :
Test case design

  • Experience-based techniques
  • Tracibility Matrix & Test Coverage
  • Defect Life Cycle, Priority & Severity of defects
  • Real time Defect reporting and practicals

Lab Session :
JIRA Tool Set Up for Tracibility matrix & Test coverage

ZEPHYR Tool : Defects reporting

  • Test organization
  • Test plans, estimates, and strategies
  • Test progress monitoring and control
  • Entry & Exit Criteria
  • API Testing (Manual Postman)
  • Why API
  • Types of API (Rest & SOPUI)
  • API Collection
  • Basic of API Testing (Get, Post, Put and delete)
  • Understanding of Path,Query,Parameters and Headers
  • Authentication
  • Add Place API and Execution through postman
  • Response Code of API
  • f Validation and assertion on response
  • Requirments of API, Understanding the API Contract

Lab Session :
Postman Setup, CRUD Functionalities

Validation of API response, Status Code

Import & Export postman collection

Course Curriculum

  • Fundamentals of Testing
  • What is Testing?
  • Testing Principles
  • What Is Software, Types of Software Application (Desktop, Web & Mobile), Types of Organizations
  • Type of Domains
  • Project & Team Members
  • Testing Throughout the Software Life Cycle
  • Software Development Models (Overview of All Models) - SDLC
  • Water Fall Model
  • Agile Model, V Shape, Spiral Model (Adv & Dis-adv), Roles
  • Agile Model, Scrum Framework, Roles, Ceremonies & Artifacts,
  • Sprint, Scrum, Test Managment Tool (JIRA, ZEPHYR)

Lab Session:

  • JIRA Tool Creating the Project, Test Cases, Basic Tool Handling
  • Fundamental Test Process (Overview of Understanding Requirements and Creating Test Scenarios, Test design, Test Planning, Test Execution, Test Report)
  • STLC

Lab Session

  • Understanding Requirements and Creating Test Scenarios

Test Types

  • White Box Testing
  • Black Box Testing
  • Functional Testing
  • Smoke & Sanity Testing
  • Regression and Retesting
  • User Acceptance Testing - Alpha & Beta Programs
  • Non-functional Testing (Overview)
  • Usability Testing
  • UI UX Testing
  • L10N, I18N, G11N Testing
  • Compatibility Testing
  • Performance Testing
  • Security Testing

Environments

  • Development, QA, UAT, Prod

Test Levels

  • Unit Testing
  • Integration Testing
  • System Testing
  • UAT Testing
  • Prod Testing
  • Experience-Based Techniques
  • Tracibility Matrix & Test Coverage
  • Defect Life Cycle, Priority & Severity of Defects
  • Real Time Defect Reporting and Practicals

Lab Session 

  • JIRA Tool Set Up for Tracibility Matrix & Test Coverage
  • ZEPHYR Tool: Defects Reporting
  • Test Organization
  • Test Plans, Estimates, and Strategies
  • Test Progress Monitoring and Control
  • Entry & Exit Criteria

Lab Sessions : Creating Defects in Jira

  • Practilcals on Creating Defects in Jira

Lab Sessions : Creating Test Cases From Requirement

  • Practical on Jira Tool for Assignements and Project Work
  • API Testing (Manual Postman)
  • Why API
  • Types of API (Rest & SoapUI)
  • API Collection
  • Basic of API Testing (Get, Post, Put and Delete)

Lab Session

  • Postman Setup, CRUD Functionalities
  • What is Automation?
  • Why Automation (Manual vs Automation)? 
  • Scope of Automation Tester in Market
  • What is Selenium? Why Selenium?
  • Advantages of Using Selenium?

Value Added Courses

  • Introduction to Database
    • What is Database? Database testing?
    • Types of Database
    • What is MYSQL?
    • DDL - Data Definition Language
    • DML - Data Manipulation Language
    • DCL - Data Control Language
    • DQL - Data Query Language
  • Overview of Database
    • MYSQL Commands
    • What is RDBMS?
    • What is table?
    • What is field?
    • What is column?
    • What is NULL value?
  • MYSQL Constraints
    • MYSQL Constraints
    • NOT NULL Constraint: Ensures that a column cannot have NULL value.
    • DEFAULT Constraint: Provides a default value for a column when none is specified.
    • UNIQUE Constraint: Ensures that all values in a column are different.
    • PRIMARY Key: Uniquely identified each rows/records in a database table.
    • FOREIGN Key: Uniquely identified a rows/records in any another database table.
    • CHECK Constraint: The CHECK constraint ensures that all values in a column satisfy certain conditions.
    • INDEX: Use to create and retrieve
    • Aggregation Functions: (Mean, Max, Count) Group by, Sorting order
  • SQL Statements and Joins
    • MYSQL Syntax
    • MYSQL SELECT Statement
    • SQL Joins
  • Understanding of Data Contract & Mapping Specifications
    • Understanding of Data COntract
    • Understanding of Mapping Specifications
    • Creating Test cases from Requirement

Contact Our Team of Experts

FAQs

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence

Call Us